﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class page1_introduce : System.Web.UI.Page
{
    public string bh1; public string bh2;
    public string bh3; public string bh4;
    public string bh5; public string bh6;
    public string bh7; public string bh8;
    public string bh9; public string url1;
    public string url2; public string url3;
    public string url4; public string url5;
    public string url6; public string url7;
    public string url8; public string url9;
    protected void Page_Load(object sender, EventArgs e)
    {
        OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0 ;Data Source=|DataDirectory|\\web.mdb");
        string sqlstr = "select * from ty_teacher";

        OleDbDataAdapter myda = new OleDbDataAdapter(sqlstr, con);
        DataSet myds = new DataSet();
        con.Open();
        myda.Fill(myds, "ty_teacher");
        bh1 = myds.Tables[0].Rows[4]["id"].ToString();
        bh2 = myds.Tables[0].Rows[3]["id"].ToString();
        bh3 = myds.Tables[0].Rows[0]["id"].ToString();
        bh4 = myds.Tables[0].Rows[1]["id"].ToString();
        bh5 = myds.Tables[0].Rows[5]["id"].ToString();
        bh6 = myds.Tables[0].Rows[8]["id"].ToString();
        bh7 = myds.Tables[0].Rows[7]["id"].ToString();
        bh8 = myds.Tables[0].Rows[2]["id"].ToString();
        bh9 = myds.Tables[0].Rows[6]["id"].ToString();
        url1 = myds.Tables[0].Rows[4]["ty_pic"].ToString();
        url2 = myds.Tables[0].Rows[3]["ty_pic"].ToString();
        url3 = myds.Tables[0].Rows[0]["ty_pic"].ToString();
        url4 = myds.Tables[0].Rows[1]["ty_pic"].ToString();
        url5 = myds.Tables[0].Rows[5]["ty_pic"].ToString();
        url6 = myds.Tables[0].Rows[8]["ty_pic"].ToString();
        url7 = myds.Tables[0].Rows[7]["ty_pic"].ToString();
        url8 = myds.Tables[0].Rows[2]["ty_pic"].ToString();
        url9 = myds.Tables[0].Rows[6]["ty_pic"].ToString();
        con.Close();
    }
}